home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / opsecurities.sql < prev    next >
Text File  |  2000-05-12  |  996b  |  25 lines
  1. /* RCSVER $Id: opsecurities.sql,v 1.2 1999-02-24 14:58:19-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        opsecurities.sql
  6. * Date:        02/17/1999
  7. * memo:        Randy Wood
  8. * Description:    Create the opsecurities table.
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE opsecurities
  12. (
  13.     op_type        NUMBER(38)    /* type of operator */
  14.         CONSTRAINT ref1_opsecurities REFERENCES optypes(op_type)
  15.         ON DELETE CASCADE,
  16.     subsys_id    NUMBER(38)    /* subsystem involved */
  17.         CONSTRAINT ref2_opsecurities REFERENCES subsystems(id)
  18.         ON DELETE CASCADE,
  19.     security_level    NUMBER(38),    /* security level to associate */
  20.     CONSTRAINT fk_opsecurities FOREIGN KEY (subsys_id, security_level) 
  21.         REFERENCES subsecurities(subsys_id, sec_level)
  22.         ON DELETE CASCADE, 
  23.     CONSTRAINT pk_opsecurities PRIMARY KEY (op_type, subsys_id)
  24. );
  25.